//=============================================================================
//===	Copyright (C) 2001-2005 Food and Agriculture Organization of the
//===	United Nations (FAO-UN), United Nations World Food Programme (WFP)
//===	and United Nations Environment Programme (UNEP)
//===
//===	This program is free software; you can redistribute it and/or modify
//===	it under the terms of the GNU General Public License as published by
//===	the Free Software Foundation; either version 2 of the License, or (at
//===	your option) any later version.
//===
//===	This program is distributed in the hope that it will be useful, but
//===	WITHOUT ANY WARRANTY; without even the implied warranty of
//===	MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
//===	General Public License for more details.
//===
//===	You should have received a copy of the GNU General Public License
//===	along with this program; if not, write to the Free Software
//===	Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
//===
//===	Contact: Jeroen Ticheler - FAO - Viale delle Terme di Caracalla 2,
//===	Rome - Italy. email: GeoNetwork@fao.org
//==============================================================================

package org.fao.geonet.services.param.branch;

import java.util.Vector;

import jeeves.constants.Jeeves;
import jeeves.interfaces.Service;
import jeeves.resources.dbms.Dbms;
import jeeves.server.ServiceConfig;
import jeeves.server.context.ServiceContext;
import jeeves.utils.Util;

import org.fao.geonet.constants.Geonet;
import org.fao.geonet.constants.Params;
import org.jdom.Element;

//=============================================================================

/**
 * Update the information of a user
 */

public class Update implements Service {
	// --------------------------------------------------------------------------
	// ---
	// --- Init
	// ---
	// --------------------------------------------------------------------------

	public void init(String appPath, ServiceConfig params) throws Exception {
	}

	// --------------------------------------------------------------------------
	// ---
	// --- Service
	// ---
	// --------------------------------------------------------------------------

	public Element exec(Element params, ServiceContext context)
			throws Exception {
		String id = params.getChildText(Params.ID);
		String id_organization = params.getChildText(Params.PARENT_ID);

		Dbms dbms = (Dbms) context.getResourceManager()
				.open(Geonet.Res.MAIN_DB);

		if (Util.getParam(params, "new_area", null) != null && id != null) {
			String areaName = Util.getParam(params, "name", null);
			int newId = context.getSerialFactory().getSerial(dbms, "area");
			dbms
					.execute(
							"INSERT INTO area (id, id_organization_branch, name ) VALUES (?, ?, ?)",
							newId, new Integer(id), areaName);
			return new Element(Jeeves.Elem.RESPONSE);
		}

		if (Util.getParam(params, "new_detail", null) != null && id != null) {
			String detailValue = Util.getParam(params, "detail_value", null);
			String detailType = Util.getParam(params, "detail_type", null);
			int newId = context.getSerialFactory().getSerial(dbms,
					"organization_branch_detail");
			dbms
					.execute(
							"INSERT INTO organization_branch_detail (id, id_organization_branch, detail_value, detail_type) VALUES (?, ?, ?, ?)",
							newId, new Integer(id), detailValue, detailType);
			return new Element(Jeeves.Elem.RESPONSE);
		}
		String name = Util.getParam(params, Params.NAME);

		String country = Util.getParam(params, Params.COUNTRY, "");
		String contact_instructions = Util.getParam(params,
				"contact_instructions", "");
		String service_hours = Util.getParam(params, "service_hours", "");
		if (Util.getParam(params, "commit", "FALSE").toString().toUpperCase()
				.equals("TRUE")) {
			if (id == null) // For Adding new element
			{
				int newId = context.getSerialFactory().getSerial(dbms,
						"organization_branch");

				dbms
						.execute(
								"INSERT INTO organization_branch (id, id_organization, name, country, contact_instructions, service_hours ) "
										+ "VALUES (?, ?, ?, ?, ?, ? )", newId,
								new Integer(id_organization), name, country,
								contact_instructions, service_hours);

			}

			else // --- For Update
			{
				dbms
						.execute(
								"UPDATE organization_branch SET name=?, country=?,"
										+ "contact_instructions=?, service_hours=? WHERE id=? AND id_organization=?",
								name, country, contact_instructions,
								service_hours, new Integer(id), new Integer(
										id_organization));

			}
		}

		return new Element(Jeeves.Elem.RESPONSE);
	}

}

// =============================================================================

